Dashboard 03 - ZipCode - Creating Line and Clustered Column charts Visualizations - Part 02
18
Step 3: Create Line and Clustered Column Chart for Average & YOY Apt. Price/Sq. Ft. by Property (Description) Desc.
Visualizations
To create the following visual, copy and paste the Average & YOY House Price/Sq. Ft. by Property Desc visual that was created in Step 1 and use it as a template.
To create a copy of the visual, click the Average & YOY House Price/Sq. Ft. by Property Desc visual , press Ctrl+C to copy, and then press Ctrl+V to paste
Fields
Select the following:
Under Visualizations, drag & drop it in the Shared Axis section:
Type_and_Use -> Type_Use_Description
DateDimension[Date] -> Year
Under Visualizations, drag & drop it in the Column Values section:
A_KeyMeasures -> .AVG_AptUnitPrice_PerSqFt%
Under Visualizations, drag & drop it in the Line Values section:
A_KeyMeasures -> .YOY_AVG_AptUnitPrice_PerSqFt%
Under Visualizations, drag & drop it in the Tooltips section:
A_KeyMeasures -> .YOY_Diff_AVG_AptUnitPrice_PerSqFt%
A_KeyMeasures -> .AVG_AptUnitPrice
Note: Remove any extra filters that are not listed here.
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
Type_and_Use -> Property Type Description
.AVG_AptUnitPrice_PerSqFt% = AVG Apt Price/Sq. Ft.
.YOY_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.YOY_Diff_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.AVG_AptUnitPrice = AVG Apt Price
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 923 , Y Position = 598 , Width = 576 , Height = 429
Under Format -> Legend -> Set it to ON , Position = Top Center , Title = OFF , Color = #000000 , Legend Name = [blank] , Font Family = Segoe UI , Text Size = 13 pt , Style = Markers Only
Under Format -> X Axis -> Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Y Axis -> Position = Left , Scale Type = Linear -> Start = 25 , Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Gridlines = ON , Line Color = #000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = #5B8F22 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Data Colors ->
YOY AVG Apt Price/Sq. Ft. = #1D0D49
AVG Apt Price/Sq. Ft. = #868291
Under Format -> Data Labels -> Set it to ON , Color = #000000 , Display Units = Auto , Value Decimal Places = 0 , Text Size = 14 pt , Font Family = Segoe UI , Show Background = Off ,
Customize Series = ON ,
(Select AVG Apt Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF) ,
(Select YOY AVG Apt Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)
Under Format -> Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Title -> Set it to ON , Title Text = Average & YOY Apt. Price/Sq. Ft. by Property Desc, Year, Quarter Month , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to ON , Color = #FFFFFF
Under Format -> Border -> Set it to ON , Color = #666666 , Radius = 5 px
Step 4 - Configure Filter(s)
Filters
None.
After completing, the visual will look as follows:
Sort visuals
Sort the 2 visuals, in descending order, by:
AVG House Price/Sq. Ft.
AVG Apt Price/Sq. Ft.
When finished, save project.
Creating a Line and Clustered Column Chart in Power BI